﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ZhimeiSoft.CharmManager.Server.DAL
{
    public class CustomerServiceItemReservationTimeDAL_Const
    {
        public static readonly string SQL_INSERT_CUSTOMERSERVICEITEMDETAIL = "INSERT INTO CUSTOMERSERVICEITEMRESERVATIONTIME (CSEQNUM, CDAYS, CMEMO, CUSTOMERSERVICEITEMID) VALUES (@CSEQNUM, @CDAYS, @CMEMO, @CUSTOMERSERVICEITEMID);";

        public static readonly string SQL_UPDATE_CUSTOMERSERVICEITEMDETAIL = "UPDATE CUSTOMERSERVICEITEMRESERVATIONTIME SET CSEQNUM=@CSEQNUM, CDAYS=@CDAYS, CMEMO=@CMEMO, CUSTOMERSERVICEITEMID=@CUSTOMERSERVICEITEMID WHERE CUSTOMERSERVICEITEMDETAILID=@CUSTOMERSERVICEITEMDETAILID";

        public static readonly string SQL_DELETE_CUSTOMERSERVICEITEMDETAIL = "DELETE FROM CUSTOMERSERVICEITEMRESERVATIONTIME";

        public static readonly string SQL_QUERY_CUSTOMERSERVICEITEMDETAIL = "SELECT * FROM CUSTOMERSERVICEITEMRESERVATIONTIME";
    }
}
